﻿CREATE TABLE [dbo].[Articles]
(
	[Id] INT IDENTITY(1,1) NOT NULL,
	[RangeReviewId] [int] NOT NULL,
	[CategoryId] [smallint] NOT NULL,
	[Code] [varchar](20) NOT NULL,
	[Name] [varchar](200) NOT NULL,
	[EAN] [varchar](50) NULL,
	[UOM] [varchar](50) NULL,
	[Brand] [varchar](255) NULL,
	[Manufacturer] [varchar](255) NULL,
	[Delist] [bit] NOT NULL, --Propuesta de Delisting
	[IsDelisted] [bit] NOT NULL, --Seria el Status. Si no está delistado, está activo
	[IsDeletedRangeReview] [bit] NOT NULL, --No participa en los reportes de RangeReview
	[IsDeletedPerformance] [bit] NOT NULL, --No participa en los reportes de Performance
	[IsNew] [bit] NOT NULL, --Es nuevo
	[Comments] [varchar](500) NULL,
	[CommentId] [int] NULL,
	[Size] [smallmoney] NULL,
	[Width] [smallmoney] NULL,
	[Height] [smallmoney] NULL,
	[Facings] [smallmoney] NULL,
	[Attribute1] [varchar](200) NULL,
	[Attribute2] [varchar](200) NULL,
	[Attribute3] [varchar](200) NULL,
	[Attribute4] [varchar](200) NULL,
	[Attribute5] [varchar](200) NULL,
	[SplitPercentage] [money] NULL, 
	[MarginSplitPercentage] [money] NULL,
	[UnitOfMeasureConvertionId] [int] NULL,
	[TaxRate] [smallmoney] NOT NULL,
	[Type] [varchar](100) NULL,
	[OrderUOM] [varchar](100) NULL,
	[OrderEAN] [varchar](100) NULL,
	[Pack] [varchar](100) NULL,
	[Vendor] [varchar](100) NULL,
	[Price] [money] NULL,
	[Cost] [money] NULL,
	[NetPrice] [money] NULL,
	[CreatedDate] [Date] NULL,
	[Source] [varchar](50) NULL
	
	

)
